﻿CREATE TABLE [dbo].[PizzaComposition] (
    [PizzaTemplateID] INT NOT NULL,
    [ToppingID]        INT NOT NULL,
    CONSTRAINT [FK_PizzaComposition_PizzaTemplate] FOREIGN KEY ([PizzaTemplateID]) REFERENCES [dbo].[PizzaTemplate] ([ID]),
    CONSTRAINT [FK_PizzaComposition_Topping] FOREIGN KEY ([ToppingID]) REFERENCES [dbo].[Topping] ([ID]),
	PRIMARY KEY (PizzaTemplateID, ToppingID)
);

